SUPPORT / SAMPLES & SAS NOTES
Problem Note 37985: Metadata generation in SAS® Customer Intelligence fails with an error if the length of a field name in the underlying database exceeds 28 characters
 |  |  |  |
In SAS Customer Intelligence, generation of metadata fails with the following error if the length of a field name in the underlying database exceeds 28 characters:
java.lang.IllegalArgumentException: An invalid resultset ID was specified. An ID of length less than 1 or greater than 32 or it may have contained an invalid character or was a reserved word. The ID specified was '[DATABASE_FIELD_NAME_EXCEEDS_28]'.
If you are using double-byte characters, the maximum length for this field is 16 characters.
There are two workarounds for this issue:
- Ensure that the names of all database fields that require metadata are 28 or fewer characters.
- Use the custom attribute, OutputColumnName, in the information map to define an alternative name for the field with a length that is less than 28 characters.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Plug-ins for SAS Management Console | Microsoft® Windows® for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| HP-UX IPF | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Linux for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Solaris for x64 | 5.3 | 5.3_M2 | 9.2 TS2M2 | 9.2 TS2M3 | ||